package com.goodmean.teacher.admin;

import com.goodmean.common.model.CourseStudentGrade;

import java.util.List;

public class CourseStudentGradeService {

    public static CourseStudentGradeService me = new CourseStudentGradeService();
    private static CourseStudentGrade dao = new CourseStudentGrade().dao();

    public List <CourseStudentGrade> findBySid(String student_id) {
        List <CourseStudentGrade> list = dao.find("SELECT * FROM course_student_grade WHERE student_id = ?", student_id);
        return list;
    }
    public List <CourseStudentGrade> findByCourseId(Integer course_id){
        return dao.find("SELECT * FROM course_student_grade WHERE course_id = ?", course_id);
    }
    public  CourseStudentGrade findByStudentIdCourseId(String student_id,Integer course_id){
        return dao.findById(course_id , student_id);
    }
}
